IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].tb_left_navigation') AND TYPE in (N'U'))
BEGIN
CREATE TABLE tb_left_navigation
(
    Id INT IDENTITY(1,1) NOT NULL,
    leftnavcode varchar(10) not null,
    zh_cn varchar(max) not null default(''),
	zh_tw varchar(max) not null default(''),
	en_us varchar(max) not null default(''),
	Url varchar(max) not null default(''),
	prettyurl varchar(max) not null default(''),
	parentid int not null default(0),
	level int not null default(0),
	Target varchar(max) not null default(''),
	CreateBy VARCHAR(100),
    CreateDate DATETIME DEFAULT(GETDATE()),
    UpdateBy VARCHAR(100),
    UpdateDate DATETIME,
    DisplayOrder smallint not null default(0),
	CONSTRAINT PK_tb_left_navigation_Id PRIMARY KEY CLUSTERED (Id)
) 
END
GO